/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * MainFrame.java
 *
 * Created on Aug 3, 2011, 11:56:50 AM
 */
package invento;

import java.sql.ResultSet;
import javax.swing.JTable;

/**
 *
 * @author Kristina
 */
public class MainFrame extends javax.swing.JFrame {
    public DbConnector dbConn = new DbConnector();
    private int rowIndex1;
    private int rowIndex2;
    private int rowIndex3;
    private int rowIndex4;
    private String inString;

     private int rowCount;
     private int colCount;
     private int rowPrint;
     private int colPrint;

    public MainFrame() {
        initComponents();
        setLocationRelativeTo(null);
        dbConn.dbConnect();
        dbConn.refreshDisplay(jTable1, jTable2, jTable3, jTable4);
        indexRefresh();
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jPopupMenu1 = new javax.swing.JPopupMenu();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        buttonAddFirearm = new javax.swing.JButton();
        buttonSendtoArchives = new javax.swing.JButton();
        buttonUpdateFirearm = new javax.swing.JButton();
        buttonViewFirearmA = new javax.swing.JButton();
        jPanel5 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jButton5 = new javax.swing.JButton();
        btnIssueFirearm = new javax.swing.JButton();
        jLabel8 = new javax.swing.JLabel();
        jTextField8 = new javax.swing.JTextField();
        jPanel3 = new javax.swing.JPanel();
        buttonAddVehicle = new javax.swing.JButton();
        buttonUpdateVehicle = new javax.swing.JButton();
        buttonSendtoArchVehicle = new javax.swing.JButton();
        buttonViewVehicleA = new javax.swing.JButton();
        jButton9 = new javax.swing.JButton();
        jPanel6 = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTable2 = new javax.swing.JTable();
        jLabel5 = new javax.swing.JLabel();
        jTextField5 = new javax.swing.JTextField();
        buttonIssueVehicle = new javax.swing.JButton();
        jPanel4 = new javax.swing.JPanel();
        buttonAddequipment = new javax.swing.JButton();
        buttonUpdateSpecEquip = new javax.swing.JButton();
        buttonSenttoArchEquip = new javax.swing.JButton();
        buttonViewEquipA = new javax.swing.JButton();
        jButton14 = new javax.swing.JButton();
        jLabel6 = new javax.swing.JLabel();
        jPanel7 = new javax.swing.JPanel();
        jScrollPane3 = new javax.swing.JScrollPane();
        jTable3 = new javax.swing.JTable();
        jTextField6 = new javax.swing.JTextField();
        buttonIssueSpecEquip = new javax.swing.JButton();
        jTextField9 = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        buttonAddpersonnel = new javax.swing.JButton();
        buttonUpdatePersonnel = new javax.swing.JButton();
        buttonMarkServ = new javax.swing.JButton();
        buttonViewPersonnelA = new javax.swing.JButton();
        jButton19 = new javax.swing.JButton();
        jPanel8 = new javax.swing.JPanel();
        jScrollPane4 = new javax.swing.JScrollPane();
        jTable4 = new javax.swing.JTable();
        jLabel7 = new javax.swing.JLabel();
        jTextField7 = new javax.swing.JTextField();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();
        jMenuItem2 = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("PNP-SAF Inventory");

        jTabbedPane1.setBackground(new java.awt.Color(0, 204, 204));
        jTabbedPane1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        jTabbedPane1.setFont(new java.awt.Font("Tahoma", 0, 18));
        jTabbedPane1.setOpaque(true);
        jTabbedPane1.setPreferredSize(new java.awt.Dimension(1180, 492));
        jTabbedPane1.setRequestFocusEnabled(false);

        jPanel1.setBackground(new java.awt.Color(129, 158, 86));
        jPanel1.setAutoscrolls(true);
        jPanel1.setVerifyInputWhenFocusTarget(false);
        jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        buttonAddFirearm.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonAddFirearm.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/ADD3.png"))); // NOI18N
        buttonAddFirearm.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonAddFirearm.setIconTextGap(10);
        buttonAddFirearm.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonAddFirearmMouseClicked(evt);
            }
        });
        buttonAddFirearm.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                buttonAddFirearmActionPerformed(evt);
            }
        });
        jPanel1.add(buttonAddFirearm, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 127, -1, -1));

        buttonSendtoArchives.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonSendtoArchives.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/SEND-TO-ARCH.png"))); // NOI18N
        buttonSendtoArchives.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonSendtoArchives.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonSendtoArchivesMouseClicked(evt);
            }
        });
        jPanel1.add(buttonSendtoArchives, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 273, -1, -1));

        buttonUpdateFirearm.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonUpdateFirearm.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/updateF.png"))); // NOI18N
        buttonUpdateFirearm.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonUpdateFirearm.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonUpdateFirearmMouseClicked(evt);
            }
        });
        jPanel1.add(buttonUpdateFirearm, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 202, -1, 65));

        buttonViewFirearmA.setFont(new java.awt.Font("Tahoma", 0, 16)); // NOI18N
        buttonViewFirearmA.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/ARCH.png"))); // NOI18N
        buttonViewFirearmA.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonViewFirearmA.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonViewFirearmAMouseClicked(evt);
            }
        });
        jPanel1.add(buttonViewFirearmA, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 348, -1, -1));

        jPanel5.setBackground(new java.awt.Color(204, 255, 204));
        jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Inventory", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 12))); // NOI18N

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {"", "", " ", "", "", "", "", "", "", "", null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null}
            },
            new String [] {
                "Property No.", "Category", "Status", "Type", "Make", "Caliber", "Serial No.", "Acquisition Date", "Acquisition Cost", "Cost of Repair", "Source"
            }
        ));
        jTable1.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS);
        jTable1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        jScrollPane1.setViewportView(jTable1);

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1038, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 416, Short.MAX_VALUE)
        );

        jPanel1.add(jPanel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 50, 1070, 440));

        jButton5.setFont(new java.awt.Font("Tahoma", 0, 16)); // NOI18N
        jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/exporttoexcel.png"))); // NOI18N
        jButton5.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        jButton5.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jButton5MouseClicked(evt);
            }
        });
        jPanel1.add(jButton5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 423, -1, -1));

        btnIssueFirearm.setFont(new java.awt.Font("Tahoma", 0, 16));
        btnIssueFirearm.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/ISSUEFIRE.png"))); // NOI18N
        btnIssueFirearm.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        btnIssueFirearm.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                btnIssueFirearmMouseClicked(evt);
            }
        });
        btnIssueFirearm.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnIssueFirearmActionPerformed(evt);
            }
        });
        jPanel1.add(btnIssueFirearm, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 52, 70, -1));

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel8.setForeground(new java.awt.Color(255, 255, 204));
        jLabel8.setText("Serial Number:");
        jPanel1.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(392, 12, -1, -1));

        jTextField8.setFont(new java.awt.Font("Tahoma", 0, 14));
        jTextField8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField8ActionPerformed(evt);
            }
        });
        jPanel1.add(jTextField8, new org.netbeans.lib.awtextra.AbsoluteConstraints(520, 10, 120, -1));

        jTabbedPane1.addTab("Firearms", new javax.swing.ImageIcon(getClass().getResource("/invento/firearm3.png")), jPanel1); // NOI18N

        jPanel3.setBackground(new java.awt.Color(129, 158, 86));
        jPanel3.setPreferredSize(new java.awt.Dimension(1180, 492));
        jPanel3.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        buttonAddVehicle.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonAddVehicle.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/addV.png"))); // NOI18N
        buttonAddVehicle.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonAddVehicle.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonAddVehicleMouseClicked(evt);
            }
        });
        jPanel3.add(buttonAddVehicle, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 127, -1, -1));

        buttonUpdateVehicle.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonUpdateVehicle.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/updateV.png"))); // NOI18N
        buttonUpdateVehicle.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonUpdateVehicle.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonUpdateVehicleMouseClicked(evt);
            }
        });
        jPanel3.add(buttonUpdateVehicle, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 200, 69, 69));

        buttonSendtoArchVehicle.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonSendtoArchVehicle.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/SEND-TO-ARCH.png"))); // NOI18N
        buttonSendtoArchVehicle.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonSendtoArchVehicle.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonSendtoArchVehicleMouseClicked(evt);
            }
        });
        jPanel3.add(buttonSendtoArchVehicle, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 273, -1, -1));

        buttonViewVehicleA.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonViewVehicleA.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/ARCH.png"))); // NOI18N
        buttonViewVehicleA.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonViewVehicleA.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonViewVehicleAMouseClicked(evt);
            }
        });
        jPanel3.add(buttonViewVehicleA, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 348, -1, -1));

        jButton9.setFont(new java.awt.Font("Tahoma", 0, 16)); // NOI18N
        jButton9.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/exporttoexcel.png"))); // NOI18N
        jButton9.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        jPanel3.add(jButton9, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 423, 69, 69));

        jPanel6.setBackground(new java.awt.Color(204, 255, 204));
        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Inventory", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 12))); // NOI18N

        jTable2.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null}
            },
            new String [] {
                "Status", "Type", "Make", "Engine No.", "Chasis No.", "Plate No.", "Property No.", "Acquisition Date", "Acquisition Cost", "Cost of Repair", "Source"
            }
        ));
        jTable2.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS);
        jTable2.setPreferredSize(new java.awt.Dimension(1125, 800));
        jScrollPane2.setViewportView(jTable2);

        javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
        jPanel6.setLayout(jPanel6Layout);
        jPanel6Layout.setHorizontalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 1038, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel6Layout.setVerticalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 416, Short.MAX_VALUE)
        );

        jPanel3.add(jPanel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 50, 1070, 440));

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel5.setForeground(new java.awt.Color(255, 255, 204));
        jLabel5.setText("Property Number:");
        jPanel3.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(392, 12, -1, -1));

        jTextField5.setFont(new java.awt.Font("Tahoma", 0, 14));
        jTextField5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField5ActionPerformed(evt);
            }
        });
        jPanel3.add(jTextField5, new org.netbeans.lib.awtextra.AbsoluteConstraints(540, 10, 106, -1));

        buttonIssueVehicle.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonIssueVehicle.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/issueV.png"))); // NOI18N
        buttonIssueVehicle.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonIssueVehicle.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonIssueVehicleMouseClicked(evt);
            }
        });
        buttonIssueVehicle.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                buttonIssueVehicleActionPerformed(evt);
            }
        });
        jPanel3.add(buttonIssueVehicle, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 52, 70, -1));

        jTabbedPane1.addTab("Mobility", new javax.swing.ImageIcon(getClass().getResource("/invento/mobile.png")), jPanel3); // NOI18N

        jPanel4.setBackground(new java.awt.Color(129, 158, 86));
        jPanel4.setPreferredSize(new java.awt.Dimension(1180, 492));
        jPanel4.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        buttonAddequipment.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonAddequipment.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/addSE.png"))); // NOI18N
        buttonAddequipment.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonAddequipment.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonAddequipmentMouseClicked(evt);
            }
        });
        jPanel4.add(buttonAddequipment, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 127, 69, 69));

        buttonUpdateSpecEquip.setFont(new java.awt.Font("Tahoma", 0, 14));
        buttonUpdateSpecEquip.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/updateSE.png"))); // NOI18N
        buttonUpdateSpecEquip.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonUpdateSpecEquip.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonUpdateSpecEquipMouseClicked(evt);
            }
        });
        jPanel4.add(buttonUpdateSpecEquip, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 202, 69, 69));

        buttonSenttoArchEquip.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonSenttoArchEquip.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/SEND-TO-ARCH.png"))); // NOI18N
        buttonSenttoArchEquip.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonSenttoArchEquip.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonSenttoArchEquipMouseClicked(evt);
            }
        });
        jPanel4.add(buttonSenttoArchEquip, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 273, 69, 69));

        buttonViewEquipA.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonViewEquipA.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/ARCH.png"))); // NOI18N
        buttonViewEquipA.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonViewEquipA.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonViewEquipAMouseClicked(evt);
            }
        });
        jPanel4.add(buttonViewEquipA, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 348, 69, 69));

        jButton14.setFont(new java.awt.Font("Tahoma", 0, 16)); // NOI18N
        jButton14.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/exporttoexcel.png"))); // NOI18N
        jButton14.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        jPanel4.add(jButton14, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 423, 69, 69));

        jLabel6.setFont(new java.awt.Font("Tahoma", 0, 16));
        jLabel6.setText("Property Number:");
        jPanel4.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(1243, 301, -1, -1));

        jPanel7.setBackground(new java.awt.Color(204, 255, 204));
        jPanel7.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Inventory", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 12))); // NOI18N

        jTable3.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null}
            },
            new String [] {
                "Status", "Type", "Serial No.", "Property No.", "Acquisition Date", "Acquisition Cost", "Cost of Repair", "Source"
            }
        ));
        jTable3.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS);
        jTable3.setPreferredSize(new java.awt.Dimension(1125, 800));
        jScrollPane3.setViewportView(jTable3);
        jTable3.getColumnModel().getColumn(7).setResizable(false);

        javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
        jPanel7.setLayout(jPanel7Layout);
        jPanel7Layout.setHorizontalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel7Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 1038, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel7Layout.setVerticalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 416, Short.MAX_VALUE)
        );

        jPanel4.add(jPanel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 50, 1070, 440));

        jTextField6.setFont(new java.awt.Font("Tahoma", 0, 14));
        jTextField6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField6ActionPerformed(evt);
            }
        });
        jPanel4.add(jTextField6, new org.netbeans.lib.awtextra.AbsoluteConstraints(1381, 300, 106, -1));

        buttonIssueSpecEquip.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonIssueSpecEquip.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/issueSE.png"))); // NOI18N
        buttonIssueSpecEquip.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonIssueSpecEquip.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonIssueSpecEquipMouseClicked(evt);
            }
        });
        jPanel4.add(buttonIssueSpecEquip, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 52, 69, 69));

        jTextField9.setFont(new java.awt.Font("Tahoma", 0, 14));
        jTextField9.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField9ActionPerformed(evt);
            }
        });
        jPanel4.add(jTextField9, new org.netbeans.lib.awtextra.AbsoluteConstraints(540, 10, 106, -1));

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel9.setForeground(new java.awt.Color(255, 255, 204));
        jLabel9.setText("Property Number:");
        jPanel4.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(392, 12, -1, -1));

        jTabbedPane1.addTab("Special Equipment", new javax.swing.ImageIcon(getClass().getResource("/invento/teargas.png")), jPanel4); // NOI18N

        jPanel2.setBackground(new java.awt.Color(129, 158, 86));
        jPanel2.setPreferredSize(new java.awt.Dimension(1180, 492));
        jPanel2.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        buttonAddpersonnel.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonAddpersonnel.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/addP.png"))); // NOI18N
        buttonAddpersonnel.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonAddpersonnel.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonAddpersonnelMouseClicked(evt);
            }
        });
        jPanel2.add(buttonAddpersonnel, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 52, 69, 69));

        buttonUpdatePersonnel.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonUpdatePersonnel.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/updateP.png"))); // NOI18N
        buttonUpdatePersonnel.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonUpdatePersonnel.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonUpdatePersonnelMouseClicked(evt);
            }
        });
        jPanel2.add(buttonUpdatePersonnel, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 127, 69, 69));

        buttonMarkServ.setFont(new java.awt.Font("Tahoma", 0, 16));
        buttonMarkServ.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/mark.png"))); // NOI18N
        buttonMarkServ.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonMarkServ.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonMarkServMouseClicked(evt);
            }
        });
        jPanel2.add(buttonMarkServ, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 202, 69, 69));

        buttonViewPersonnelA.setFont(new java.awt.Font("Tahoma", 0, 14));
        buttonViewPersonnelA.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/viewP.png"))); // NOI18N
        buttonViewPersonnelA.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        buttonViewPersonnelA.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                buttonViewPersonnelAMouseClicked(evt);
            }
        });
        jPanel2.add(buttonViewPersonnelA, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 275, 69, 69));

        jButton19.setFont(new java.awt.Font("Tahoma", 0, 16)); // NOI18N
        jButton19.setIcon(new javax.swing.ImageIcon(getClass().getResource("/invento/exporttoexcel.png"))); // NOI18N
        jButton19.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        jButton19.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton19ActionPerformed(evt);
            }
        });
        jPanel2.add(jButton19, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 348, 69, 69));

        jPanel8.setBackground(new java.awt.Color(204, 255, 204));
        jPanel8.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Inventory", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 12))); // NOI18N

        jTable4.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null}
            },
            new String [] {
                "Unit", "Batallion", "Company", "Rank", "Badge Number", "Last Name", "First Name", "Middle Name", "Qualifier", "Unit Code"
            }
        ));
        jTable4.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS);
        jScrollPane4.setViewportView(jTable4);

        javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
        jPanel8.setLayout(jPanel8Layout);
        jPanel8Layout.setHorizontalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 1038, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel8Layout.setVerticalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 405, Short.MAX_VALUE)
                .addContainerGap())
        );

        jPanel2.add(jPanel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 50, 1070, 440));

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel7.setForeground(new java.awt.Color(255, 255, 204));
        jLabel7.setText("Badge Number:");
        jPanel2.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(392, 12, -1, -1));

        jTextField7.setFont(new java.awt.Font("Tahoma", 0, 14));
        jTextField7.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField7ActionPerformed(evt);
            }
        });
        jPanel2.add(jTextField7, new org.netbeans.lib.awtextra.AbsoluteConstraints(540, 10, 106, -1));

        jTabbedPane1.addTab("Personnel", new javax.swing.ImageIcon(getClass().getResource("/invento/person.png")), jPanel2); // NOI18N

        jMenu1.setText("File");

        jMenuItem1.setText("Edit Profile");
        jMenu1.add(jMenuItem1);

        jMenuItem2.setText("Logout");
        jMenuItem2.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jMenuItem2MouseClicked(evt);
            }
        });
        jMenu1.add(jMenuItem2);

        jMenuBar1.add(jMenu1);

        setJMenuBar(jMenuBar1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 1221, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jTabbedPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 557, Short.MAX_VALUE)
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void buttonAddFirearmActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_buttonAddFirearmActionPerformed
        // TODO add your handling code here:
        
        
    }//GEN-LAST:event_buttonAddFirearmActionPerformed

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        EditProfile editLogin = new EditProfile();
        editLogin.setLocation(200, 200);
        editLogin.setVisible(true);
                // TODO add your handling code here:
    }  
    
    private void buttonAddFirearmMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonAddFirearmMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        AddFirearm addfirearmwindow = new AddFirearm(this, jTable1);
        addfirearmwindow.setLocationRelativeTo(null);
        addfirearmwindow.setResizable(false);
        addfirearmwindow.setVisible(true);
     
    }//GEN-LAST:event_buttonAddFirearmMouseClicked

    private void buttonAddVehicleMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonAddVehicleMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        
        AddVehicle addvehiclewindow = new AddVehicle(this, jTable2);
        addvehiclewindow.setLocationRelativeTo(null);
        addvehiclewindow.setResizable(false);
        addvehiclewindow.setVisible(true);
    }//GEN-LAST:event_buttonAddVehicleMouseClicked

    private void buttonAddequipmentMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonAddequipmentMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        
        AddSpecEquipment addequipmentwindow = new AddSpecEquipment(this, jTable3);
        addequipmentwindow.setLocationRelativeTo(null);
        addequipmentwindow.setResizable(false);
        addequipmentwindow.setVisible(true);
    }//GEN-LAST:event_buttonAddequipmentMouseClicked

    private void buttonAddpersonnelMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonAddpersonnelMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        AddPersonnel addpersonnelwindow = new AddPersonnel(this, jTable4);
        addpersonnelwindow.setLocationRelativeTo(null);
        addpersonnelwindow.setResizable(false);
        addpersonnelwindow.setVisible(true);
    }//GEN-LAST:event_buttonAddpersonnelMouseClicked

    private void buttonUpdateFirearmMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonUpdateFirearmMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        UpdateFirearm updatefirearmwindow = new UpdateFirearm(this);
        updatefirearmwindow.setLocationRelativeTo(null);
        updatefirearmwindow.setResizable(false);
        updatefirearmwindow.setVisible(true);
        
    }//GEN-LAST:event_buttonUpdateFirearmMouseClicked

    private void buttonUpdateVehicleMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonUpdateVehicleMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        UpdateMobiity updatevehiclewindow = new UpdateMobiity(this);
        updatevehiclewindow.setLocationRelativeTo(null);
        updatevehiclewindow.setResizable(false);
        updatevehiclewindow.setVisible(true);
    }//GEN-LAST:event_buttonUpdateVehicleMouseClicked

    private void buttonUpdateSpecEquipMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonUpdateSpecEquipMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        UpdateSpecEquipment updatespecequipwindow = new UpdateSpecEquipment(this);
        updatespecequipwindow.setLocationRelativeTo(null);
        updatespecequipwindow.setResizable(false);
        updatespecequipwindow.setVisible(true);
        
    }//GEN-LAST:event_buttonUpdateSpecEquipMouseClicked

    private void buttonUpdatePersonnelMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonUpdatePersonnelMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        UpdatePersonnel updatepersonnelwindow = new UpdatePersonnel(this);
        updatepersonnelwindow.setLocationRelativeTo(null);
        updatepersonnelwindow.setResizable(false);
        updatepersonnelwindow.setVisible(true);
    }//GEN-LAST:event_buttonUpdatePersonnelMouseClicked

    private void buttonSendtoArchivesMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonSendtoArchivesMouseClicked
        // TODO add your handling code here:

                    
        this.setEnabled(false);
        ConfirmArchives confirm = new ConfirmArchives(this, jTable1, "firearm");
        confirm.setLocationRelativeTo(null);
        confirm.setResizable(false);
        confirm.setVisible(true);
        
        
    }//GEN-LAST:event_buttonSendtoArchivesMouseClicked

    private void buttonSendtoArchVehicleMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonSendtoArchVehicleMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        ConfirmArchives confirm = new ConfirmArchives(this, jTable1, "vehicle");
        confirm.setLocationRelativeTo(null);
        confirm.setResizable(false);
        confirm.setVisible(true);
    }//GEN-LAST:event_buttonSendtoArchVehicleMouseClicked

    private void buttonSenttoArchEquipMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonSenttoArchEquipMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        ConfirmArchives confirm = new ConfirmArchives(this, jTable1, "equipment");
        confirm.setLocationRelativeTo(null);
        confirm.setResizable(false);
        confirm.setVisible(true);
    }//GEN-LAST:event_buttonSenttoArchEquipMouseClicked

    private void buttonMarkServMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonMarkServMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        MarkOutService markoutservicewindow = new MarkOutService(this);
        markoutservicewindow.setLocationRelativeTo(null);
        markoutservicewindow.setResizable(false);
        markoutservicewindow.setVisible(true);
    }//GEN-LAST:event_buttonMarkServMouseClicked

    private void buttonViewFirearmAMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonViewFirearmAMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        FirearmArchives firearmarchiveswindow = new FirearmArchives(this);
        firearmarchiveswindow.setLocationRelativeTo(null);
        firearmarchiveswindow.setResizable(false);
        firearmarchiveswindow.setVisible(true);
    }//GEN-LAST:event_buttonViewFirearmAMouseClicked

    private void buttonViewVehicleAMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonViewVehicleAMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        VehicleArchives vehiclearchiveswindow = new VehicleArchives(this);
        vehiclearchiveswindow.setLocationRelativeTo(null);
        vehiclearchiveswindow.setResizable(false);
        vehiclearchiveswindow.setVisible(true);
    }//GEN-LAST:event_buttonViewVehicleAMouseClicked

    private void buttonViewEquipAMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonViewEquipAMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        EquipArchives equipmentarchiveswindow = new EquipArchives(this);
        equipmentarchiveswindow.setLocationRelativeTo(null);
        equipmentarchiveswindow.setResizable(false);
        equipmentarchiveswindow.setVisible(true);
    }//GEN-LAST:event_buttonViewEquipAMouseClicked

    private void buttonViewPersonnelAMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonViewPersonnelAMouseClicked
        // TODO add your handling code here:
        this.setEnabled(false);
        OutOfServPersonnel outofservicewindow = new OutOfServPersonnel(this);
        outofservicewindow.setLocationRelativeTo(null);
        outofservicewindow.setResizable(false);
        outofservicewindow.setVisible(true);
    
    }//GEN-LAST:event_buttonViewPersonnelAMouseClicked

    private void jButton19ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton19ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jButton19ActionPerformed

    private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField5ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jTextField5ActionPerformed

    private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField6ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jTextField6ActionPerformed

    private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField7ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jTextField7ActionPerformed

    private void btnIssueFirearmMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_btnIssueFirearmMouseClicked
   
        this.setEnabled(false);
        IssueFirearm issuefirearmwindow = new IssueFirearm(this);
        issuefirearmwindow.showScreen();
        
    }//GEN-LAST:event_btnIssueFirearmMouseClicked

    private void buttonIssueVehicleMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonIssueVehicleMouseClicked
        // TODO add your handling code here:
         this.setEnabled(false);
        IssueVehicle issuevehiclewindow = new IssueVehicle(this);
        issuevehiclewindow.showScreen();
    }//GEN-LAST:event_buttonIssueVehicleMouseClicked

    private void buttonIssueSpecEquipMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_buttonIssueSpecEquipMouseClicked
        // TODO add your handling code here:
         this.setEnabled(false);
        IssueSpecEquip issuespecequipwindow = new IssueSpecEquip(this);
        issuespecequipwindow.showScreen();
    }//GEN-LAST:event_buttonIssueSpecEquipMouseClicked

    private void btnIssueFirearmActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnIssueFirearmActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_btnIssueFirearmActionPerformed

    private void jTextField8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField8ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jTextField8ActionPerformed

private void buttonIssueVehicleActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_buttonIssueVehicleActionPerformed
// TODO add your handling code here:
}//GEN-LAST:event_buttonIssueVehicleActionPerformed

private void jTextField9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField9ActionPerformed
// TODO add your handling code here:
}//GEN-LAST:event_jTextField9ActionPerformed

private void jButton5MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton5MouseClicked
    
    TestExcel excel = new TestExcel("firearm");
    //excel.main();
    
}//GEN-LAST:event_jButton5MouseClicked

private void jMenuItem2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jMenuItem2MouseClicked
    this.setVisible(false);
    new Login2().setVisible(true);
}//GEN-LAST:event_jMenuItem2MouseClicked

    public void showScreen(){
        this.setLocationRelativeTo(null);
        this.setResizable(false);
        this.setVisible(true);
    }
    
        public void indexRefresh()
    {
        rowIndex1 = jTable1.getSelectedRow();
        rowIndex2 = jTable2.getSelectedRow();
        rowIndex3 = jTable3.getSelectedRow();
        rowIndex4 = jTable4.getSelectedRow();
    }

    public int tableRefresh(JTable parent, int rowIndex)
    {
        rowIndex = parent.getSelectedRow();
        return rowIndex;
    }

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new MainFrame().setVisible(false);
            }
        });
    }
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton btnIssueFirearm;
    private javax.swing.JButton buttonAddFirearm;
    private javax.swing.JButton buttonAddVehicle;
    private javax.swing.JButton buttonAddequipment;
    private javax.swing.JButton buttonAddpersonnel;
    private javax.swing.JButton buttonIssueSpecEquip;
    private javax.swing.JButton buttonIssueVehicle;
    private javax.swing.JButton buttonMarkServ;
    private javax.swing.JButton buttonSendtoArchVehicle;
    private javax.swing.JButton buttonSendtoArchives;
    private javax.swing.JButton buttonSenttoArchEquip;
    private javax.swing.JButton buttonUpdateFirearm;
    private javax.swing.JButton buttonUpdatePersonnel;
    private javax.swing.JButton buttonUpdateSpecEquip;
    private javax.swing.JButton buttonUpdateVehicle;
    private javax.swing.JButton buttonViewEquipA;
    private javax.swing.JButton buttonViewFirearmA;
    private javax.swing.JButton buttonViewPersonnelA;
    private javax.swing.JButton buttonViewVehicleA;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton19;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton9;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JMenuItem jMenuItem1;
    private javax.swing.JMenuItem jMenuItem2;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPopupMenu jPopupMenu1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable2;
    private javax.swing.JTable jTable3;
    private javax.swing.JTable jTable4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.JTextField jTextField6;
    private javax.swing.JTextField jTextField7;
    private javax.swing.JTextField jTextField8;
    private javax.swing.JTextField jTextField9;
    // End of variables declaration//GEN-END:variables
}
